UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZiXemKzFSC1rjICBlbWOyO9pqzkTw2wlWuF02y918U='
WHERE
key_id = '4f1ae779f80b894d6ea8e4b8254d8ce719073cf22740732bd7f38c53a7b6efea'
AND (
token = 'tZiXemKzFSC1rjICBlbWOyO9pqzkTw2wlWuF02y918U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)