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