UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'akpB03KpM+hAI3u5kxJen9Y/TqjU8dFD8VBKH+2U9Yk='
WHERE
key_id = '42120cef761853c8ad80ca7c5b1e174c6bb0c7532a50a7ab5cbae25bf5b29420'
AND (
token = 'akpB03KpM+hAI3u5kxJen9Y/TqjU8dFD8VBKH+2U9Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)