UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1ITYhG8Ih5dun+WHl+kTR6Ijv0avj0eTy4mCR3hkwuA=' 
WHERE 
  key_id = '96e6260aa9f62432fd1c0b69b1b2f7c28cc8127fdd9799123b612965d7a55932' 
  AND (
    token = '1ITYhG8Ih5dun+WHl+kTR6Ijv0avj0eTy4mCR3hkwuA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033