UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c6PiAfrpWitsKTLtQH8eD2UkY9M3+w5WaKlaiYdgYIQ='
WHERE
key_id = 'a8dab1b0f8f8743b940c45e5efcfca2758b79ccf051c350aca37eb5f64df0184'
AND (
token = 'c6PiAfrpWitsKTLtQH8eD2UkY9M3+w5WaKlaiYdgYIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)