UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'trQonb08IyGHwiu8Z7Ba69X0TNwkNQUalCuXnC8fHbg='
WHERE
key_id = 'cbb39b6af74b9169a56cb558dcfd767b85f9bd6cfdd77210a5704d9dd50bff8e'
AND (
token = 'trQonb08IyGHwiu8Z7Ba69X0TNwkNQUalCuXnC8fHbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)