UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LXUCaI1e0Uw+dM8s9WW8ACoaI1yp8ee/KwJ3AgEab7Q='
WHERE
key_id = 'f01d276a93c824168f9a1485dc2e8d24df7364a1074406b4c0b98682e50373c6'
AND (
token = 'LXUCaI1e0Uw+dM8s9WW8ACoaI1yp8ee/KwJ3AgEab7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)