UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xiMYQI/dur3sf0HqEJ+3vWtlmvDiGBngApRfoV85pY='
WHERE
key_id = '190f6e9bd87f9b770107dc7af09e80bdcce13f0626a5538f0b1ab628b9b444ad'
AND (
token = '0xiMYQI/dur3sf0HqEJ+3vWtlmvDiGBngApRfoV85pY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)