UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XK05T8z24H0JRiEO4iX+qNl3/W5087Np6hS4PDKsujw='
WHERE
key_id = 'f387d8611a09f75afd4610ee710ae1c5872d700c8ac1eae8768461812aeb601a'
AND (
token = 'XK05T8z24H0JRiEO4iX+qNl3/W5087Np6hS4PDKsujw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)