UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VCpGXvaWMS+z7R4Nop8+nefiCQXYsg8hsEBUcZNerNw=' 
WHERE 
  key_id = 'd4cf108f2451ea687cc2eff45d62a312e3d332b19e265e8f65f9e467cf187342' 
  AND (
    token = 'VCpGXvaWMS+z7R4Nop8+nefiCQXYsg8hsEBUcZNerNw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023