UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eXoTLMlFcQunWEyD9QVWHCXyE/4IRaUDbkOgVMMlPsM=' 
WHERE 
  key_id = 'cb9055d5c3ac68b1ccbcdb8bf9a31532977e8cfe2a781096d7655826e9bccd55' 
  AND (
    token = 'eXoTLMlFcQunWEyD9QVWHCXyE/4IRaUDbkOgVMMlPsM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038