UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HYz3HN7PqhUXmZ0I0eJYaS3gYSsjwYWza3uZTXhZDK8='
WHERE
key_id = '7053b56748c4b805122ded7e18c6a9c7549b16740319314c300a613e85583aa5'
AND (
token = 'HYz3HN7PqhUXmZ0I0eJYaS3gYSsjwYWza3uZTXhZDK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)