UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6KBnQW8b4zcYrYiAmMhNhMYODerY+T+4rkjcBxn2aHc='
WHERE
key_id = 'f697a8684f527acd5832cd3ea68934c29f91b887c34c9ebbac9404e8bdf61fa0'
AND (
token = '6KBnQW8b4zcYrYiAmMhNhMYODerY+T+4rkjcBxn2aHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)