UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0PuahiIfLPk9yKl25JcxUFswUQkqLCuAyJkxZpr2Qzg=' 
WHERE 
  key_id = '20332a33dd43d637f6e68016fbfcaf4ded9b8c8312bbbce64bf0e158973a9283' 
  AND (
    token = '0PuahiIfLPk9yKl25JcxUFswUQkqLCuAyJkxZpr2Qzg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034