UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '09cHpk9YiXJFotTsLWMDRXxRL5bfCLeLtlW3XD8USYQ=' 
WHERE 
  key_id = '5cf0b9cd50f5e264779e1f7d3089b2d09de41a19b4326e3addfd2e5f54c76acb' 
  AND (
    token = '09cHpk9YiXJFotTsLWMDRXxRL5bfCLeLtlW3XD8USYQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035