UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'reyiQK5/X7o9QLb/bsqU4JjWtBooiSVXCqm/udcX4Go='
WHERE
key_id = '2bffd7a867869cf06a9264bc897d03b526ada02f548d3c32be9f8da75e19f0cb'
AND (
token = 'reyiQK5/X7o9QLb/bsqU4JjWtBooiSVXCqm/udcX4Go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)