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