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