UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VVDblgbyGeYgz2m5IuCWmxhcGHw+EX+o4Zbvu6b2jM='
WHERE
key_id = '0ffc7801f77d49c0deb8a275634b4adf375bac9798c81a3c9b15e88e86571177'
AND (
token = '9VVDblgbyGeYgz2m5IuCWmxhcGHw+EX+o4Zbvu6b2jM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)