UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nkjYZi7pYuqUFHVG5RyzJH9UfzcHCiahzpn42BhZpQ='
WHERE
key_id = 'e04fdc2f5ebff36e9ef486616ec1a4a60b10a28146b206498a836c048f4daa6a'
AND (
token = '0nkjYZi7pYuqUFHVG5RyzJH9UfzcHCiahzpn42BhZpQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)