UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XUS2YZp4ftQpMAFYALklHxwl7T3u1J8mPI8RRErOCG4='
WHERE
key_id = 'ad16524300028b96ce7321a2ff778e20392597f86c16a6c69f6f203d396f928f'
AND (
token = 'XUS2YZp4ftQpMAFYALklHxwl7T3u1J8mPI8RRErOCG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)