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