UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mhsmqeWI1kwH6RQ4xx+7w75fqCJjOXkMiK2V5Q7A8jI='
WHERE
key_id = 'f381fbf4ed717c7c878b5491052c049311c0f4a359754019f4e14860799b823d'
AND (
token = 'mhsmqeWI1kwH6RQ4xx+7w75fqCJjOXkMiK2V5Q7A8jI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)