UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Fq4Py9kZa0WAaBK2N6ewPZP3u+BmmEa25BTuP/gFoY='
WHERE
key_id = '7f212d6dc8cc9f6f7e3d62a6a6d34ba3cc0ab3a5ab5b4eddb4cd6362daca5bf5'
AND (
token = '9Fq4Py9kZa0WAaBK2N6ewPZP3u+BmmEa25BTuP/gFoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)