UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78hVZnqrW0FUdhvOtBRYg2KkRV963A4kSmdvgbtLCTY='
WHERE
key_id = '5b6cbbac1e767513dee59408858b391035f0a08532e29cbc0b7f8a99d96f754a'
AND (
token = '78hVZnqrW0FUdhvOtBRYg2KkRV963A4kSmdvgbtLCTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)