UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm9Pg4ACOjdXtgFSV4MrSX4ZvtaE9djznpiIYOZN0ARU='
WHERE
key_id = '47dc8d137dc645ff5074f013068c3cc9458bbc73db5d6b57986355951329a4f0'
AND (
token = 'm9Pg4ACOjdXtgFSV4MrSX4ZvtaE9djznpiIYOZN0ARU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)