UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A2ssn0WCmuFMXprZEkwSr7CKuF/uN5JpOi/KYB5KZLA='
WHERE
key_id = '670ef6875f88e26c69e5fa26d85de0a194d547f0c79d36fa61fe0565ce21551c'
AND (
token = 'A2ssn0WCmuFMXprZEkwSr7CKuF/uN5JpOi/KYB5KZLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)