UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jTV94ndvjwMf9yqYb2ZYKtg9bYSyaqil7cB0VhtQjJo=' 
WHERE 
  key_id = 'd7c014e19a146b21af7d290e2528e2c8f879a6bf421fe7cd30d8dfd2ac13adcb' 
  AND (
    token = 'jTV94ndvjwMf9yqYb2ZYKtg9bYSyaqil7cB0VhtQjJo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037