UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9DzVWk4Il+hvjL28a1VX6QxpFLGQ1QOLaIZE8Abv5bE='
WHERE
key_id = '401d0ec1b53ec7edce331bfb23ae4704b8c0a417e71ed849316febbb8ed21051'
AND (
token = '9DzVWk4Il+hvjL28a1VX6QxpFLGQ1QOLaIZE8Abv5bE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)