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