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