UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RKvTaqM4n4wDku4soxxagivBrMl4Htnhn9oPi+lCjoY='
WHERE
key_id = 'c8ff8022fe90a162bde1f5b5cb4a11e9611fdde007800cfff63e44343be546a9'
AND (
token = 'RKvTaqM4n4wDku4soxxagivBrMl4Htnhn9oPi+lCjoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)