UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A7gES2wQ03u0BjPOvhKgaCT3dk4LMvSl7e9KBTHhxpc='
WHERE
key_id = '569817eb5b6f5d7941deb072d5e4073dbe79408c5eeceb8c1a36b418dd6982bd'
AND (
token = 'A7gES2wQ03u0BjPOvhKgaCT3dk4LMvSl7e9KBTHhxpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)