UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6ir7mC0isSY0ATQTyy0JLc5DdLNZU4RfmxA55ibecU='
WHERE
key_id = 'ff3881635b533400cdb784723a86468a7e49a5824e01e7f843f7031a0cbb6866'
AND (
token = 'o6ir7mC0isSY0ATQTyy0JLc5DdLNZU4RfmxA55ibecU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)